﻿CREATE TABLE [Announcements].[Announcements]
(
	AnnouncementID int NOT NULL IDENTITY(1, 1), 
	Title varchar(50) NOT NULL,
	ShortDescription varchar(255) NOT NULL,
	LongDescription text NULL,
	StartDate smalldatetime NOT NULL,
	EndDate smalldatetime NOT NULL,
	Link varchar(255) NULL
)
